<?php
require($_SERVER['DOCUMENT_ROOT'] . "/bootstrap.php");
$user = $_SESSION['email'];
$listorder1 = mysql_query(@"
    SELECT * 
    FROM listorder li , STATUS st , USER u
    WHERE li.`iduser` = u.`id`
    AND li.`idstatus` = st.`idstatus`
    AND u.`email`     = '$user'
	order by orderdatecreate desc
");

while ($row = mysql_fetch_array($listorder1)) {
    $listorder[] = $row;
}
if(!isset($listorder))
        $listorder = '';

$smarty->assign("listorder", $listorder);
$smarty->display('../templates/listorder/index.tpl');
?>

